outer combinator

outer combinator

Description

This function adds the _outer suffix to the end of the function name of the table function, and thus changes the function from non-outer to outer. It adds a row of Null data when the table function generates 0 rows of data.

Example

mysql> select e1 from (select 1 k1) as t lateral view explode_numbers(0) tmp1 as e1;
Empty set

mysql> select e1 from (select 1 k1) as t lateral view explode_numbers_outer(0) tmp1 as e1;
+------+
| e1   |
+------+
| NULL |
+------+

Keywords

outer